vignettes/higher_ed_institutions.Rmd
higher_ed_institutions.Rmd
library(studentenstatistikNRW)
library(tibble)
hochschulen
#> # A tibble: 540 × 46
#> Hochschulart_Hochschu…¹ Hochschule_Signatur Hochschule Hochschule_EN `Hs-Nr.`
#> <chr> <chr> <chr> <chr> <dbl>
#> 1 10725 001 Universit… University o… 142
#> 2 60515 002 APOLLON H… University o… 361
#> 3 60265 003 Hochschul… Macromedia U… 366
#> 4 61074 004 Fachhochs… FH Diakonie,… 375
#> 5 60129 006 Hochschul… German Unive… 457
#> 6 11034 008 Universit… University o… 71
#> 7 11060 012 Universit… University o… 215
#> 8 11065 013 Universit… University o… 245
#> 9 11070 014 Universit… University o… 279
#> 10 11040 015 Fernunive… FernUniversi… 100
#> # ℹ 530 more rows
#> # ℹ abbreviated name: ¹Hochschulart_Hochschule_Signatur
#> # ℹ 41 more variables: Wiki_ID_DE <dbl>, Wikidata_ID <chr>, Wiki_ID_EN <dbl>,
#> # Wiki_Key_EN <chr>, Wiki_Logo_DE <chr>, Wiki_Logo_DE_File <chr>,
#> # Wiki_Logo_DE_Description <chr>, Wiki_Logo_DE_URL <chr>,
#> # Wiki_Logo_DE_Thumbnail_URL <chr>, ROR_ID <chr>, Multirank <chr>, Ort <chr>,
#> # Domain_Hochschule_HRK <chr>, CHE_DAAD_University_ID <dbl>, …gt Package
As of March 13, 2024, the Federal Statistical Office of Germany (Destatis) lists a total of 427 institutions of higher education in the country. In this vignette, we will use this official data source as basis and go through considerable efforts to complement this data with other sources. In particular:
We will download all key tables for the student statistics (table series 372) provided by the Federal Statistical Agency (Destatis) on its data collection portal (Erhebungsportal). There are four key tables / csv files containing data on institutions of higher education in Germany: 1.) Hochschule, 2.) HochschulStandort, 3.) HochschuleErsteinschreibung, and 4.) HochschulFachbereich, each with slight differences in how and where institutions are counted (e.g. when a university has subsidiary campuses in other cities and German states),
we will then match the Destatis data with the list of all institutions of higher education in Germany provided by the German Rector’s Conference (HRK). The Federal Statistical Agency data together with the HRK list are the “most authoritative German numbers” that exist.
As described in vignette("ror"), we use the global
Research Organization Registry (ROR) REST API to retrieve additional
data and identifiers which are then matched to the existing
data.
This is the exhaustive list of additional data sources that are linked up:
links to the German and English Wikipedia article for each institution,
links to the Wikidata entry for each institution and a separate link to each institution’s German logo, if available,
the link to each institution on studieren.de,
the link to the CHE University Ranking for each institution hosted by the German Academic Exchange Service in English,
the link for each institution’s multirank for 2022-2023,
fs::file_delete(
unique(logo_url_written[!is.na(logo_url_written)])
)